﻿using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace eTerm.PlugIn.TicketImport {
    
        #region 未定义
        /// <summary>
        /// Table: PNR_Cabin
        /// Primary Key: ID
        /// </summary>
        public class PNR_CabinTable: DatabaseTable {
            public PNR_CabinTable(IDataProvider provider):base("PNR_Cabin",provider){
                ClassName = "PnrCabin";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("AirWayCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 50,
                    PropertyName = "AirWayCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("CabinCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 10,
                    PropertyName = "CabinCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Discount", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Decimal,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 5,
                    PropertyName = "Discount"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Description", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "Description"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn AirWayCode{
                get{
                    return this.GetColumn("AirWayCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn CabinCode{
                get{
                    return this.GetColumn("CabinCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Discount{
                get{
                    return this.GetColumn("Discount");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Description{
                get{
                    return this.GetColumn("Description");
                }
            }
        }
        #endregion
        
        #region 未定义
        /// <summary>
        /// Table: PNR_Detr
        /// Primary Key: ID
        /// </summary>
        public class PNR_DetrTable: DatabaseTable {
            public PNR_DetrTable(IDataProvider provider):base("PNR_Detr",provider){
                ClassName = "PnrDetr";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("UserID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 4,
                    PropertyName = "UserId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("TicketNo", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 36,
                    PropertyName = "TicketNo"
                });
                //未定义
                Columns.Add(new DatabaseColumn("ProcessDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "ProcessDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("StatusID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "StatusId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("DetrDescription", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4000,
                    PropertyName = "DetrDescription"
                });
                //未定义
                Columns.Add(new DatabaseColumn("TicketDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "TicketDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("SyncStatus", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "SyncStatus"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn UserId{
                get{
                    return this.GetColumn("UserID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn TicketNo{
                get{
                    return this.GetColumn("TicketNo");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn ProcessDate{
                get{
                    return this.GetColumn("ProcessDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn StatusId{
                get{
                    return this.GetColumn("StatusID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn DetrDescription{
                get{
                    return this.GetColumn("DetrDescription");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn TicketDate{
                get{
                    return this.GetColumn("TicketDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn SyncStatus{
                get{
                    return this.GetColumn("SyncStatus");
                }
            }
        }
        #endregion
        
        #region 票号处理历史
        /// <summary>
        /// Table: PNR_History
        /// Primary Key: ID
        /// </summary>
        public class PNR_HistoryTable: DatabaseTable {
            public PNR_HistoryTable(IDataProvider provider):base("PNR_History",provider){
                ClassName = "PnrHistory";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("TicketNoID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int64,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 8,
                    PropertyName = "TicketNoId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("SourceStatusID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "SourceStatusId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("NewStatusID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "NewStatusId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("ProcessDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "ProcessDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("DetrInfo", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4000,
                    PropertyName = "DetrInfo"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn TicketNoId{
                get{
                    return this.GetColumn("TicketNoID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn SourceStatusId{
                get{
                    return this.GetColumn("SourceStatusID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn NewStatusId{
                get{
                    return this.GetColumn("NewStatusID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn ProcessDate{
                get{
                    return this.GetColumn("ProcessDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn DetrInfo{
                get{
                    return this.GetColumn("DetrInfo");
                }
            }
        }
        #endregion
        
        #region 未定义
        /// <summary>
        /// Table: PNR_Passenger
        /// Primary Key: ID
        /// </summary>
        public class PNR_PassengerTable: DatabaseTable {
            public PNR_PassengerTable(IDataProvider provider):base("PNR_Passenger",provider){
                ClassName = "PnrPassenger";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("PassengerName", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 50,
                    PropertyName = "PassengerName"
                });
                //未定义
                Columns.Add(new DatabaseColumn("IdentityNo", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 50,
                    PropertyName = "IdentityNo"
                });
                //未定义
                Columns.Add(new DatabaseColumn("PassengerType", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "PassengerType"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Birthday", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Birthday"
                });
                //未定义
                Columns.Add(new DatabaseColumn("IdentityType", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "IdentityType"
                });
                //未定义
                Columns.Add(new DatabaseColumn("TicketNoID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int64,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 8,
                    PropertyName = "TicketNoId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("RequireID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int64,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 8,
                    PropertyName = "RequireId"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn PassengerName{
                get{
                    return this.GetColumn("PassengerName");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn IdentityNo{
                get{
                    return this.GetColumn("IdentityNo");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn PassengerType{
                get{
                    return this.GetColumn("PassengerType");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Birthday{
                get{
                    return this.GetColumn("Birthday");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn IdentityType{
                get{
                    return this.GetColumn("IdentityType");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn TicketNoId{
                get{
                    return this.GetColumn("TicketNoID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn RequireId{
                get{
                    return this.GetColumn("RequireID");
                }
            }
        }
        #endregion
        
        #region 占座PNR库
        /// <summary>
        /// Table: PNR_Require
        /// Primary Key: ID
        /// </summary>
        public class PNR_RequireTable: DatabaseTable {
            public PNR_RequireTable(IDataProvider provider):base("PNR_Require",provider){
                ClassName = "PnrRequire";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("UserID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 4,
                    PropertyName = "UserId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("PNRCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 25,
                    PropertyName = "PnrCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Description", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4000,
                    PropertyName = "Description"
                });
                //未定义
                Columns.Add(new DatabaseColumn("StatusID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "StatusId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("RecordDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "RecordDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("RequireCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 36,
                    PropertyName = "RequireCode"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn UserId{
                get{
                    return this.GetColumn("UserID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn PnrCode{
                get{
                    return this.GetColumn("PNRCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Description{
                get{
                    return this.GetColumn("Description");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn StatusId{
                get{
                    return this.GetColumn("StatusID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn RecordDate{
                get{
                    return this.GetColumn("RecordDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn RequireCode{
                get{
                    return this.GetColumn("RequireCode");
                }
            }
        }
        #endregion
        
        #region 未定义
        /// <summary>
        /// Table: PNR_RequireCode
        /// Primary Key: ID
        /// </summary>
        public class PNR_RequireCodeTable: DatabaseTable {
            public PNR_RequireCodeTable(IDataProvider provider):base("PNR_RequireCode",provider){
                ClassName = "PnrRequireCode";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("SegmentID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int64,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 8,
                    PropertyName = "SegmentId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("CabinCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 10,
                    PropertyName = "CabinCode"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn SegmentId{
                get{
                    return this.GetColumn("SegmentID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn CabinCode{
                get{
                    return this.GetColumn("CabinCode");
                }
            }
        }
        #endregion
        
        #region 未定义
        /// <summary>
        /// Table: PNR_Segment
        /// Primary Key: ID
        /// </summary>
        public class PNR_SegmentTable: DatabaseTable {
            public PNR_SegmentTable(IDataProvider provider):base("PNR_Segment",provider){
                ClassName = "PnrSegment";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("RequireID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int64,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 8,
                    PropertyName = "RequireId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Departure", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 20,
                    PropertyName = "Departure"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Arrival", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 20,
                    PropertyName = "Arrival"
                });
                //未定义
                Columns.Add(new DatabaseColumn("DepartureDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "DepartureDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("CabinCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "CabinCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("TicketNoID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int64,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 8,
                    PropertyName = "TicketNoId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("FlightNo", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 20,
                    PropertyName = "FlightNo"
                });
                //未定义
                Columns.Add(new DatabaseColumn("IsInvalid", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Boolean,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 1,
                    PropertyName = "IsInvalid"
                });
                //未定义
                Columns.Add(new DatabaseColumn("StartRangeTime", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 25,
                    PropertyName = "StartRangeTime"
                });
                //未定义
                Columns.Add(new DatabaseColumn("EndRangeTime", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 25,
                    PropertyName = "EndRangeTime"
                });
                //未定义
                Columns.Add(new DatabaseColumn("StatusID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "StatusId"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn RequireId{
                get{
                    return this.GetColumn("RequireID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Departure{
                get{
                    return this.GetColumn("Departure");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Arrival{
                get{
                    return this.GetColumn("Arrival");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn DepartureDate{
                get{
                    return this.GetColumn("DepartureDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn CabinCode{
                get{
                    return this.GetColumn("CabinCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn TicketNoId{
                get{
                    return this.GetColumn("TicketNoID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn FlightNo{
                get{
                    return this.GetColumn("FlightNo");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn IsInvalid{
                get{
                    return this.GetColumn("IsInvalid");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn StartRangeTime{
                get{
                    return this.GetColumn("StartRangeTime");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn EndRangeTime{
                get{
                    return this.GetColumn("EndRangeTime");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn StatusId{
                get{
                    return this.GetColumn("StatusID");
                }
            }
        }
        #endregion
        
        #region 未定义
        /// <summary>
        /// Table: PNR_SentHistory
        /// Primary Key: ID
        /// </summary>
        public class PNR_SentHistoryTable: DatabaseTable {
            public PNR_SentHistoryTable(IDataProvider provider):base("PNR_SentHistory",provider){
                ClassName = "PnrSentHistory";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("GroupCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 36,
                    PropertyName = "GroupCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("SentDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "SentDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("PacketName", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 500,
                    PropertyName = "PacketName"
                });
                //未定义
                Columns.Add(new DatabaseColumn("PacketResult", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 0,
                    PropertyName = "PacketResult"
                });
                //未定义
                Columns.Add(new DatabaseColumn("RequireID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int64,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "RequireId"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn GroupCode{
                get{
                    return this.GetColumn("GroupCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn SentDate{
                get{
                    return this.GetColumn("SentDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn PacketName{
                get{
                    return this.GetColumn("PacketName");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn PacketResult{
                get{
                    return this.GetColumn("PacketResult");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn RequireId{
                get{
                    return this.GetColumn("RequireID");
                }
            }
        }
        #endregion
        
        #region 页面权限表
        /// <summary>
        /// Table: Sys_Authority
        /// Primary Key: AuthorityCode
        /// </summary>
        public class Sys_AuthorityTable: DatabaseTable {
            public Sys_AuthorityTable(IDataProvider provider):base("Sys_Authority",provider){
                ClassName = "SysAuthority";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("AuthorityCode", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.String,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 36,
                    PropertyName = "AuthorityCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("AuthorityName", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "AuthorityName"
                });
                //未定义
                Columns.Add(new DatabaseColumn("AuthorityUrl", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "AuthorityUrl"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Description", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "Description"
                });
                //未定义
                Columns.Add(new DatabaseColumn("ParentCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 36,
                    PropertyName = "ParentCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Icon", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "Icon"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn AuthorityCode{
                get{
                    return this.GetColumn("AuthorityCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn AuthorityName{
                get{
                    return this.GetColumn("AuthorityName");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn AuthorityUrl{
                get{
                    return this.GetColumn("AuthorityUrl");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Description{
                get{
                    return this.GetColumn("Description");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn ParentCode{
                get{
                    return this.GetColumn("ParentCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Icon{
                get{
                    return this.GetColumn("Icon");
                }
            }
        }
        #endregion
        
        #region 未定义
        /// <summary>
        /// Table: Sys_Company
        /// Primary Key: CompanyCode
        /// </summary>
        public class Sys_CompanyTable: DatabaseTable {
            public Sys_CompanyTable(IDataProvider provider):base("Sys_Company",provider){
                ClassName = "SysCompany";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("CompanyCode", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.String,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 36,
                    PropertyName = "CompanyCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("CompayName", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "CompayName"
                });
                //未定义
                Columns.Add(new DatabaseColumn("CreateDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "CreateDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Description", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "Description"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn CompanyCode{
                get{
                    return this.GetColumn("CompanyCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn CompayName{
                get{
                    return this.GetColumn("CompayName");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn CreateDate{
                get{
                    return this.GetColumn("CreateDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Description{
                get{
                    return this.GetColumn("Description");
                }
            }
        }
        #endregion
        
        #region 系统日志表
        /// <summary>
        /// Table: Sys_DbLog
        /// Primary Key: ID
        /// </summary>
        public class Sys_DbLogTable: DatabaseTable {
            public Sys_DbLogTable(IDataProvider provider):base("Sys_DbLog",provider){
                ClassName = "SysDbLog";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("LogType", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "LogType"
                });
                //未定义
                Columns.Add(new DatabaseColumn("LogDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "LogDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Logger", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "Logger"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Description", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 0,
                    PropertyName = "Description"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn LogType{
                get{
                    return this.GetColumn("LogType");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn LogDate{
                get{
                    return this.GetColumn("LogDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Logger{
                get{
                    return this.GetColumn("Logger");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Description{
                get{
                    return this.GetColumn("Description");
                }
            }
        }
        #endregion
        
        #region 未定义
        /// <summary>
        /// Table: Sys_Mail
        /// Primary Key: ID
        /// </summary>
        public class Sys_MailTable: DatabaseTable {
            public Sys_MailTable(IDataProvider provider):base("Sys_Mail",provider){
                ClassName = "SysMail";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("ID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int64,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "Id"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Sender", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "Sender"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Receiver", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 500,
                    PropertyName = "Receiver"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Subject", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 500,
                    PropertyName = "Subject"
                });
                //未定义
                Columns.Add(new DatabaseColumn("BodyHtml", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 0,
                    PropertyName = "BodyHtml"
                });
                //未定义
                Columns.Add(new DatabaseColumn("BodyXml", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 0,
                    PropertyName = "BodyXml"
                });
                //未定义
                Columns.Add(new DatabaseColumn("ProcessDate", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.DateTime,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 8,
                    PropertyName = "ProcessDate"
                });
                //未定义
                Columns.Add(new DatabaseColumn("MailStatusID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "MailStatusId"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Id{
                get{
                    return this.GetColumn("ID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Sender{
                get{
                    return this.GetColumn("Sender");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Receiver{
                get{
                    return this.GetColumn("Receiver");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Subject{
                get{
                    return this.GetColumn("Subject");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn BodyHtml{
                get{
                    return this.GetColumn("BodyHtml");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn BodyXml{
                get{
                    return this.GetColumn("BodyXml");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn ProcessDate{
                get{
                    return this.GetColumn("ProcessDate");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn MailStatusId{
                get{
                    return this.GetColumn("MailStatusID");
                }
            }
        }
        #endregion
        
        #region 用户表
        /// <summary>
        /// Table: Sys_User
        /// Primary Key: UserID
        /// </summary>
        public class Sys_UserTable: DatabaseTable {
            public Sys_UserTable(IDataProvider provider):base("Sys_User",provider){
                ClassName = "SysUser";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("UserID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "UserId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("CompanyCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 36,
                    PropertyName = "CompanyCode"
                });
                //未定义
                Columns.Add(new DatabaseColumn("UserNo", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 50,
                    PropertyName = "UserNo"
                });
                //未定义
                Columns.Add(new DatabaseColumn("DisplayName", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 50,
                    PropertyName = "DisplayName"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Password", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 50,
                    PropertyName = "Password"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Email", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "Email"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Mobile", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 30,
                    PropertyName = "Mobile"
                });
                //未定义
                Columns.Add(new DatabaseColumn("Description", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = false,
                    MaxLength = 255,
                    PropertyName = "Description"
                });
                //未定义
                Columns.Add(new DatabaseColumn("ParentID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 4,
                    PropertyName = "ParentId"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn UserId{
                get{
                    return this.GetColumn("UserID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn CompanyCode{
                get{
                    return this.GetColumn("CompanyCode");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn UserNo{
                get{
                    return this.GetColumn("UserNo");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn DisplayName{
                get{
                    return this.GetColumn("DisplayName");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Password{
                get{
                    return this.GetColumn("Password");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Email{
                get{
                    return this.GetColumn("Email");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Mobile{
                get{
                    return this.GetColumn("Mobile");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Description{
                get{
                    return this.GetColumn("Description");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn ParentId{
                get{
                    return this.GetColumn("ParentID");
                }
            }
        }
        #endregion
        
        #region 用户权限关联表
        /// <summary>
        /// Table: Sys_UserAuthority
        /// Primary Key: RID
        /// </summary>
        public class Sys_UserAuthorityTable: DatabaseTable {
            public Sys_UserAuthorityTable(IDataProvider provider):base("Sys_UserAuthority",provider){
                ClassName = "SysUserAuthority";
                SchemaName = "dbo";
                //未定义
                Columns.Add(new DatabaseColumn("RID", this)
                {
                    IsPrimaryKey = true,
                    DataType = DbType.Int32,
                    IsNullable = false,
                    AutoIncrement = true,
                    IsForeignKey = false,
                    MaxLength = 4,
                    PropertyName = "Rid"
                });
                //未定义
                Columns.Add(new DatabaseColumn("UserID", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.Int32,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 4,
                    PropertyName = "UserId"
                });
                //未定义
                Columns.Add(new DatabaseColumn("AuthorityCode", this)
                {
                    IsPrimaryKey = false,
                    DataType = DbType.String,
                    IsNullable = true,
                    AutoIncrement = false,
                    IsForeignKey = true,
                    MaxLength = 36,
                    PropertyName = "AuthorityCode"
                });
            }
            
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn Rid{
                get{
                    return this.GetColumn("RID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn UserId{
                get{
                    return this.GetColumn("UserID");
                }
            }
            /// <summary>
            /// 获取列名：未定义.
            /// </summary>
            /// <value>未定义.</value>
            public IColumn AuthorityCode{
                get{
                    return this.GetColumn("AuthorityCode");
                }
            }
        }
        #endregion
        
}        